// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_MST_CUSTOMER
// * CreateDate    : 2014-06-05 18:30:14
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:14
// * LastChanger   : 2014-06-05 18:30:14
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class MstCustomerTable : TableInfo
    {
		public const string C_TableName = "MST_CUSTOMER";
		
		public const string C_ID = "ID";
		public const string C_UPDATED_BY = "UPDATED_BY";
		public const string C_UPDATED_DATE = "UPDATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_IS_ACTIVE = "IS_ACTIVE";
		public const string C_CUSTOMER_CODE = "CUSTOMER_CODE";
		public const string C_CUSTOMER_NAME = "CUSTOMER_NAME";
		public const string C_CUSTOMER_FULL_NAME = "CUSTOMER_FULL_NAME";
		public const string C_INDUSTRY_TYPE_CODE = "INDUSTRY_TYPE_CODE";
		public const string C_LEVEL = "LEVEL";
		public const string C_CONTACT_DEPARTMENT = "CONTACT_DEPARTMENT";
		public const string C_CONTACT_NAME = "CONTACT_NAME";
		public const string C_CONTACT_MOBILE_PHONE = "CONTACT_MOBILE_PHONE";
		public const string C_CONTACT_AGE = "CONTACT_AGE";
		public const string C_CONTACT_JOB_TITLE = "CONTACT_JOB_TITLE";
		public const string C_CONTACT_OFFICE_PHONE = "CONTACT_OFFICE_PHONE";
		public const string C_CONTACT_FAX = "CONTACT_FAX";
		public const string C_CONTACT_EMAIL = "CONTACT_EMAIL";
		public const string C_CONTACT_REMARK = "CONTACT_REMARK";
		public const string C_COUNTORY = "COUNTORY";
		public const string C_PROVINCE = "PROVINCE";
		public const string C_CITY = "CITY";
		public const string C_ADDRESS = "ADDRESS";
		public const string C_ZIP_CODE = "ZIP_CODE";
		public const string C_EMAIL = "EMAIL";
		public const string C_TELEPHONE = "TELEPHONE";
		public const string C_FAX = "FAX";
		public const string C_DEFAULT_CURRENCY = "DEFAULT_CURRENCY";
		public const string C_BANK = "BANK";
		public const string C_BANK_ACCOUNT = "BANK_ACCOUNT";
		public const string C_TAX_ACCOUNT = "TAX_ACCOUNT";
		public const string C_LEGAL_REPRESENTATIVE = "LEGAL_REPRESENTATIVE";
		public const string C_LEGAL_AGENT = "LEGAL_AGENT";
		public const string C_RECEIVED_PERSON = "RECEIVED_PERSON";
		public const string C_RECEIVED_ADDRESS = "RECEIVED_ADDRESS";
		public const string C_CREDIT_LIMIT = "CREDIT_LIMIT";
		public const string C_PAYMENT_TYPE = "PAYMENT_TYPE";
		public const string C_STATUS = "STATUS";
		
		public MstCustomerTable()
        {
            _tableName = "MST_CUSTOMER";
        }
		
		protected static MstCustomerTable _current;
        public static MstCustomerTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new MstCustomerTable();

            _current.Add(C_ID, new ColumnInfo(C_ID,"Id", true, typeof(string)));
            _current.Add(C_UPDATED_BY, new ColumnInfo(C_UPDATED_BY,"UpdatedBy", false, typeof(string)));
            _current.Add(C_UPDATED_DATE, new ColumnInfo(C_UPDATED_DATE,"UpdatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_IS_ACTIVE, new ColumnInfo(C_IS_ACTIVE,"IsActive", false, typeof(int)));
            _current.Add(C_CUSTOMER_CODE, new ColumnInfo(C_CUSTOMER_CODE,"CustomerCode", false, typeof(string)));
            _current.Add(C_CUSTOMER_NAME, new ColumnInfo(C_CUSTOMER_NAME,"CustomerName", false, typeof(string)));
            _current.Add(C_CUSTOMER_FULL_NAME, new ColumnInfo(C_CUSTOMER_FULL_NAME,"CustomerFullName", false, typeof(string)));
            _current.Add(C_INDUSTRY_TYPE_CODE, new ColumnInfo(C_INDUSTRY_TYPE_CODE,"IndustryTypeCode", false, typeof(string)));
            _current.Add(C_LEVEL, new ColumnInfo(C_LEVEL,"Level", false, typeof(string)));
            _current.Add(C_CONTACT_DEPARTMENT, new ColumnInfo(C_CONTACT_DEPARTMENT,"ContactDepartment", false, typeof(string)));
            _current.Add(C_CONTACT_NAME, new ColumnInfo(C_CONTACT_NAME,"ContactName", false, typeof(string)));
            _current.Add(C_CONTACT_MOBILE_PHONE, new ColumnInfo(C_CONTACT_MOBILE_PHONE,"ContactMobilePhone", false, typeof(string)));
            _current.Add(C_CONTACT_AGE, new ColumnInfo(C_CONTACT_AGE,"ContactAge", false, typeof(int)));
            _current.Add(C_CONTACT_JOB_TITLE, new ColumnInfo(C_CONTACT_JOB_TITLE,"ContactJobTitle", false, typeof(string)));
            _current.Add(C_CONTACT_OFFICE_PHONE, new ColumnInfo(C_CONTACT_OFFICE_PHONE,"ContactOfficePhone", false, typeof(string)));
            _current.Add(C_CONTACT_FAX, new ColumnInfo(C_CONTACT_FAX,"ContactFax", false, typeof(string)));
            _current.Add(C_CONTACT_EMAIL, new ColumnInfo(C_CONTACT_EMAIL,"ContactEmail", false, typeof(string)));
            _current.Add(C_CONTACT_REMARK, new ColumnInfo(C_CONTACT_REMARK,"ContactRemark", false, typeof(string)));
            _current.Add(C_COUNTORY, new ColumnInfo(C_COUNTORY,"Countory", false, typeof(string)));
            _current.Add(C_PROVINCE, new ColumnInfo(C_PROVINCE,"Province", false, typeof(string)));
            _current.Add(C_CITY, new ColumnInfo(C_CITY,"City", false, typeof(string)));
            _current.Add(C_ADDRESS, new ColumnInfo(C_ADDRESS,"Address", false, typeof(string)));
            _current.Add(C_ZIP_CODE, new ColumnInfo(C_ZIP_CODE,"ZipCode", false, typeof(string)));
            _current.Add(C_EMAIL, new ColumnInfo(C_EMAIL,"Email", false, typeof(string)));
            _current.Add(C_TELEPHONE, new ColumnInfo(C_TELEPHONE,"Telephone", false, typeof(string)));
            _current.Add(C_FAX, new ColumnInfo(C_FAX,"Fax", false, typeof(string)));
            _current.Add(C_DEFAULT_CURRENCY, new ColumnInfo(C_DEFAULT_CURRENCY,"DefaultCurrency", false, typeof(string)));
            _current.Add(C_BANK, new ColumnInfo(C_BANK,"Bank", false, typeof(string)));
            _current.Add(C_BANK_ACCOUNT, new ColumnInfo(C_BANK_ACCOUNT,"BankAccount", false, typeof(string)));
            _current.Add(C_TAX_ACCOUNT, new ColumnInfo(C_TAX_ACCOUNT,"TaxAccount", false, typeof(string)));
            _current.Add(C_LEGAL_REPRESENTATIVE, new ColumnInfo(C_LEGAL_REPRESENTATIVE,"LegalRepresentative", false, typeof(string)));
            _current.Add(C_LEGAL_AGENT, new ColumnInfo(C_LEGAL_AGENT,"LegalAgent", false, typeof(string)));
            _current.Add(C_RECEIVED_PERSON, new ColumnInfo(C_RECEIVED_PERSON,"ReceivedPerson", false, typeof(string)));
            _current.Add(C_RECEIVED_ADDRESS, new ColumnInfo(C_RECEIVED_ADDRESS,"ReceivedAddress", false, typeof(string)));
            _current.Add(C_CREDIT_LIMIT, new ColumnInfo(C_CREDIT_LIMIT,"CreditLimit", false, typeof(string)));
            _current.Add(C_PAYMENT_TYPE, new ColumnInfo(C_PAYMENT_TYPE,"PaymentType", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
			
		}
		
		public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }
		
		public ColumnInfo UPDATED_BY
        {
            get { return this[C_UPDATED_BY]; }
        }
		
		public ColumnInfo UPDATED_DATE
        {
            get { return this[C_UPDATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo IS_ACTIVE
        {
            get { return this[C_IS_ACTIVE]; }
        }
		
		public ColumnInfo CUSTOMER_CODE
        {
            get { return this[C_CUSTOMER_CODE]; }
        }
		
		public ColumnInfo CUSTOMER_NAME
        {
            get { return this[C_CUSTOMER_NAME]; }
        }
		
		public ColumnInfo CUSTOMER_FULL_NAME
        {
            get { return this[C_CUSTOMER_FULL_NAME]; }
        }
		
		public ColumnInfo INDUSTRY_TYPE_CODE
        {
            get { return this[C_INDUSTRY_TYPE_CODE]; }
        }
		
		public ColumnInfo LEVEL
        {
            get { return this[C_LEVEL]; }
        }
		
		public ColumnInfo CONTACT_DEPARTMENT
        {
            get { return this[C_CONTACT_DEPARTMENT]; }
        }
		
		public ColumnInfo CONTACT_NAME
        {
            get { return this[C_CONTACT_NAME]; }
        }
		
		public ColumnInfo CONTACT_MOBILE_PHONE
        {
            get { return this[C_CONTACT_MOBILE_PHONE]; }
        }
		
		public ColumnInfo CONTACT_AGE
        {
            get { return this[C_CONTACT_AGE]; }
        }
		
		public ColumnInfo CONTACT_JOB_TITLE
        {
            get { return this[C_CONTACT_JOB_TITLE]; }
        }
		
		public ColumnInfo CONTACT_OFFICE_PHONE
        {
            get { return this[C_CONTACT_OFFICE_PHONE]; }
        }
		
		public ColumnInfo CONTACT_FAX
        {
            get { return this[C_CONTACT_FAX]; }
        }
		
		public ColumnInfo CONTACT_EMAIL
        {
            get { return this[C_CONTACT_EMAIL]; }
        }
		
		public ColumnInfo CONTACT_REMARK
        {
            get { return this[C_CONTACT_REMARK]; }
        }
		
		public ColumnInfo COUNTORY
        {
            get { return this[C_COUNTORY]; }
        }
		
		public ColumnInfo PROVINCE
        {
            get { return this[C_PROVINCE]; }
        }
		
		public ColumnInfo CITY
        {
            get { return this[C_CITY]; }
        }
		
		public ColumnInfo ADDRESS
        {
            get { return this[C_ADDRESS]; }
        }
		
		public ColumnInfo ZIP_CODE
        {
            get { return this[C_ZIP_CODE]; }
        }
		
		public ColumnInfo EMAIL
        {
            get { return this[C_EMAIL]; }
        }
		
		public ColumnInfo TELEPHONE
        {
            get { return this[C_TELEPHONE]; }
        }
		
		public ColumnInfo FAX
        {
            get { return this[C_FAX]; }
        }
		
		public ColumnInfo DEFAULT_CURRENCY
        {
            get { return this[C_DEFAULT_CURRENCY]; }
        }
		
		public ColumnInfo BANK
        {
            get { return this[C_BANK]; }
        }
		
		public ColumnInfo BANK_ACCOUNT
        {
            get { return this[C_BANK_ACCOUNT]; }
        }
		
		public ColumnInfo TAX_ACCOUNT
        {
            get { return this[C_TAX_ACCOUNT]; }
        }
		
		public ColumnInfo LEGAL_REPRESENTATIVE
        {
            get { return this[C_LEGAL_REPRESENTATIVE]; }
        }
		
		public ColumnInfo LEGAL_AGENT
        {
            get { return this[C_LEGAL_AGENT]; }
        }
		
		public ColumnInfo RECEIVED_PERSON
        {
            get { return this[C_RECEIVED_PERSON]; }
        }
		
		public ColumnInfo RECEIVED_ADDRESS
        {
            get { return this[C_RECEIVED_ADDRESS]; }
        }
		
		public ColumnInfo CREDIT_LIMIT
        {
            get { return this[C_CREDIT_LIMIT]; }
        }
		
		public ColumnInfo PAYMENT_TYPE
        {
            get { return this[C_PAYMENT_TYPE]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		
		
	}
}

